# sqlite_crud.py
from .database import sqlite_db

async def get_sqlite_items():
    query = "SELECT * FROM items"
    return await sqlite_db.fetch_all(query)

async def create_sqlite_item(name: str, price: float):
    query = "INSERT INTO items (name, price) VALUES (:name, :price)"
    return await sqlite_db.execute(
        query,
        values={"name": name, "price": price}
    )